Smartsheet User 99 ✭✭✭

Overview

Overview

Roles	Member
Badges	8

About Me

About Me

Analytics

36

Posts

49

Visits

99

Points

Mar 24, 2022

Join Date

Mar 21, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 9

  9
• Awesome 2

  2

• Activity
• Posts5
• Comments31

• Re: Birthday/Anniversary Formula & Reminders

  Smartsheet User 99

  04/08/22
  Here is the formula to keep the Date and Month of the Hire, but adding current year to it =DATE(YEAR(TODAY()), MONTH([Company Date of Hire]@row), DAY([Company Date of Hire]@row)) Here is the formula …
  3 ·

• Re: If Formula RGY with numbers greater than, less than and zero

  Smartsheet User 99

  04/08/22
  =IF(ISBLANK([Budget Variance]@row), "", IF([Budget Variance]@row = 0, "Yellow", IF([Budget Variance]@row > 0, "Green", IF([Budget Variance]@row < 0, "Red"…
  1 ·